home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Agent Central Host Computer
/
Agent - Central Host Computer.iso
/
_SETUP.1
/
vbcsummary.sql
< prev
next >
Wrap
Text File
|
2000-05-12
|
653b
|
12 lines
CREATE OR REPLACE VIEW vbcsummary AS
SELECT vbillcoins.DET_SEQ_NUM, vbillcoins.CONV_DATE, vbillcoins.ALARM,
vbillcoins.CURR_TYPE, vbillcoins.TABLE_CODE, OPERATOR_CONTEXT.FAREBOX_GLID,
OPERATOR_CONTEXT.USER_ID,
DRIVER_CONTEXT.ROUTE_ID, DRIVER_CONTEXT.RUN_ID, DRIVER_CONTEXT.TRIP_ID, BUS.bus_id
FROM vbillcoins, MSTRREC, OPERATOR_CONTEXT, DRIVER_CONTEXT , BUS, FAREBOX
WHERE vbillcoins.det_seq_num = MSTRREC.det_seq_num AND
MSTRREC.OPERATOR_CONTEXT = OPERATOR_CONTEXT.op_context_id AND
MSTRREC.DRIVER_CONTEXT = DRIVER_CONTEXT.DRIVER_CONTEXT_ID AND
BUS.glid = FAREBOX.location AND
FAREBOX.glid = OPERATOR_CONTEXT.farebox_glid